{
 "cells": [
  {
   "cell_type": "markdown",
   "id": "2f7626a4",
   "metadata": {},
   "source": [
    "## 地理/逆地理编码\n",
    "* 结构化地址的定义：\n",
    "> 首先，地址肯定是一串字符，内含国家、省份、城市、区县、城镇、乡村、街道、门牌号码、屋邨、大厦等建筑物名称。按照由大区域名称到小区域名称组合在一起的字符。一个有效的地址应该是独一无二的。注意：针对大陆、港、澳地区的地理编码转换时可以将国家信息选择性的忽略，但省、市、城镇等级别的地址构成是不能忽略的。暂时不支持返回台湾省的详细地址信息。\n",
    "* 结构化地址《--》经纬度\n",
    "> 地理编码/逆地理编码 API 是通过 HTTP/HTTPS 协议访问远程服务的接口，提供结构化地址与经纬度之间的相互转化的能力。\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "6eac42c1",
   "metadata": {},
   "outputs": [],
   "source": [
    "# 1.调用requests 模块（Google Chrome 浏览器）\n",
    "import requests\n",
    "\n",
    "# 2.请求方法： GET       \n",
    "\n",
    "# 3.URL：https://restapi.amap.com/v3/geocode/geo?parameters\n",
    "geo_url = \"https://restapi.amap.com/v3/geocode/geo?parameters\"\n",
    "\n",
    "# 4.准备参数，用于交换数据payload\n",
    "# payload用字典的形式来写\n",
    "payload = {\n",
    "    \"key\":\"0184fe0ae6b4b0efe89cbac8da9ac0ac\",\n",
    "    \"address\":\"广东省广州市从化区\"\n",
    "}\n",
    "\n",
    "# 5.发起请求\n",
    "r = requests.get(url=geo_url,params=payload)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "id": "220d706b",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<Response [200]>"
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "r"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "id": "e75709af",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "{'status': '1',\n",
       " 'info': 'OK',\n",
       " 'infocode': '10000',\n",
       " 'count': '1',\n",
       " 'geocodes': [{'formatted_address': '广东省广州市从化区',\n",
       "   'country': '中国',\n",
       "   'province': '广东省',\n",
       "   'citycode': '020',\n",
       "   'city': '广州市',\n",
       "   'district': '从化区',\n",
       "   'township': [],\n",
       "   'neighborhood': {'name': [], 'type': []},\n",
       "   'building': {'name': [], 'type': []},\n",
       "   'adcode': '440117',\n",
       "   'street': [],\n",
       "   'number': [],\n",
       "   'location': '113.586605,23.548852',\n",
       "   'level': '区县'}]}"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "r.json()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "id": "f07ac9b8",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'113.586605,23.548852'"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "广州南方学院_location = r.json()[ 'geocodes'][0]['location']\n",
    "广州南方学院_location "
   ]
  },
  {
   "cell_type": "markdown",
   "id": "dc5f8e20",
   "metadata": {},
   "source": [
    "## 逆地理编码"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "id": "66af0d59",
   "metadata": {},
   "outputs": [],
   "source": [
    "# extensions = all\n",
    "# 1.调用requests 模块（Google Chrome 浏览器）\n",
    "import requests\n",
    "\n",
    "# 2.请求方法： GET       \n",
    "\n",
    "# 3.URL：https://restapi.amap.com/v3/geocode/regeo?parameters\n",
    "geo_url = \"https://restapi.amap.com/v3/geocode/regeo?parameters\"\n",
    "\n",
    "# 4.准备参数，用于交换数据payload\n",
    "# payload用字典的形式来写\n",
    "payload = {\n",
    "    \"key\":\"0184fe0ae6b4b0efe89cbac8da9ac0ac\",\n",
    "    \"location\":广州南方学院_location ,\n",
    "    \"extensions\":\"all\",\n",
    "    \"poitype\":\"true\"\n",
    "}\n",
    "\n",
    "# 5.发起请求\n",
    "r = requests.get(url=geo_url,params=payload)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "id": "a4fe4938",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<Response [200]>"
      ]
     },
     "execution_count": 23,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "r"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "id": "846d56e2",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "{'status': '1',\n",
       " 'info': 'OK',\n",
       " 'infocode': '10000',\n",
       " 'regeocode': {'formatted_address': '广东省广州市从化区街口街道中心会堂',\n",
       "  'addressComponent': {'country': '中国',\n",
       "   'province': '广东省',\n",
       "   'city': '广州市',\n",
       "   'citycode': '020',\n",
       "   'district': '从化区',\n",
       "   'adcode': '440117',\n",
       "   'township': '街口街道',\n",
       "   'towncode': '440117001000',\n",
       "   'neighborhood': {'name': [], 'type': []},\n",
       "   'building': {'name': [], 'type': []},\n",
       "   'streetNumber': {'street': '新城东路',\n",
       "    'number': '99号',\n",
       "    'location': '113.586615,23.548660',\n",
       "    'direction': '南',\n",
       "    'distance': '21.3686'},\n",
       "   'businessAreas': [{'location': '113.586019,23.546975',\n",
       "     'name': '街口',\n",
       "     'id': '440117'},\n",
       "    {'location': '113.568684,23.563922', 'name': '城郊', 'id': '440117'},\n",
       "    {'location': '113.604074,23.533964', 'name': '江埔', 'id': '440117'}]},\n",
       "  'pois': [{'id': 'B00140MR5X',\n",
       "    'name': '中国银行(广州从化支行)',\n",
       "    'type': '金融保险服务;银行;中国银行',\n",
       "    'tel': '020-87929678;020-87923974',\n",
       "    'direction': '南',\n",
       "    'distance': '103.541',\n",
       "    'location': '113.586937,23.547972',\n",
       "    'address': '街口镇新城东路74号',\n",
       "    'poiweight': '0.374805',\n",
       "    'businessarea': '街口'},\n",
       "   {'id': 'B0FFGJ24FS',\n",
       "    'name': '从化区人大常委会',\n",
       "    'type': '政府机构及社会团体;政府机关;区县级政府及事业单位',\n",
       "    'tel': '020-87926111',\n",
       "    'direction': '东南',\n",
       "    'distance': '13.791',\n",
       "    'location': '113.586679,23.548748',\n",
       "    'address': '街口街道新城东路99号大院内',\n",
       "    'poiweight': '0.165926',\n",
       "    'businessarea': '街口'},\n",
       "   {'id': 'B0FFGJ24FT',\n",
       "    'name': '从化区政协',\n",
       "    'type': '政府机构及社会团体;政府机关;区县级政府及事业单位',\n",
       "    'tel': '020-87922613',\n",
       "    'direction': '东南',\n",
       "    'distance': '13.791',\n",
       "    'location': '113.586679,23.548748',\n",
       "    'address': '新城东路99',\n",
       "    'poiweight': '0.165926',\n",
       "    'businessarea': '街口'},\n",
       "   {'id': 'B0014072CF',\n",
       "    'name': '广州市从化区人民政府',\n",
       "    'type': '政府机构及社会团体;政府机关;区县级政府及事业单位',\n",
       "    'tel': '020-87928410;020-87922712',\n",
       "    'direction': '南',\n",
       "    'distance': '66.6705',\n",
       "    'location': '113.586405,23.548281',\n",
       "    'address': '新城东路99号',\n",
       "    'poiweight': '0.529579',\n",
       "    'businessarea': '街口'},\n",
       "   {'id': 'B00141PSGY',\n",
       "    'name': '从化区委组织部',\n",
       "    'type': '政府机构及社会团体;政府机关;区县级政府及事业单位',\n",
       "    'tel': '020-87922092',\n",
       "    'direction': '西南',\n",
       "    'distance': '0.66843',\n",
       "    'location': '113.586600,23.548848',\n",
       "    'address': '街口街新城东路99号',\n",
       "    'poiweight': '0.245493',\n",
       "    'businessarea': '街口'},\n",
       "   {'id': 'B00141PSC0',\n",
       "    'name': '从化区委宣传部',\n",
       "    'type': '政府机构及社会团体;政府机关;区县级政府及事业单位',\n",
       "    'tel': '020-87922221',\n",
       "    'direction': '西南',\n",
       "    'distance': '0.66843',\n",
       "    'location': '113.586600,23.548848',\n",
       "    'address': '街口街新城东路99号',\n",
       "    'poiweight': '0.249396',\n",
       "    'businessarea': '街口'},\n",
       "   {'id': 'B0FFGJ24ZR',\n",
       "    'name': '中共广州市从化区委员会',\n",
       "    'type': '政府机构及社会团体;政府机关;区县级政府及事业单位',\n",
       "    'tel': [],\n",
       "    'direction': '东南',\n",
       "    'distance': '13.791',\n",
       "    'location': '113.586679,23.548748',\n",
       "    'address': '新城东路99',\n",
       "    'poiweight': '0.165926',\n",
       "    'businessarea': '街口'},\n",
       "   {'id': 'B00140ICZY',\n",
       "    'name': '中心会堂',\n",
       "    'type': '科教文化服务;会展中心;会展中心',\n",
       "    'tel': [],\n",
       "    'direction': '东南',\n",
       "    'distance': '0.532943',\n",
       "    'location': '113.586608,23.548848',\n",
       "    'address': '新城东路99',\n",
       "    'poiweight': '0.276118',\n",
       "    'businessarea': '街口'},\n",
       "   {'id': 'B00140V14Y',\n",
       "    'name': '国美电器(从化店)',\n",
       "    'type': '购物服务;家电电子卖场;国美',\n",
       "    'tel': '020-37939789',\n",
       "    'direction': '东',\n",
       "    'distance': '129.768',\n",
       "    'location': '113.587771,23.548384',\n",
       "    'address': '街口街荔香村1期1-3栋2层',\n",
       "    'poiweight': '0.287666',\n",
       "    'businessarea': '街口'},\n",
       "   {'id': 'B00140MJ8Z',\n",
       "    'name': '苏宁易购(从化街口路店)',\n",
       "    'type': '购物服务;家电电子卖场;苏宁',\n",
       "    'tel': '19902230595',\n",
       "    'direction': '西南',\n",
       "    'distance': '145.411',\n",
       "    'location': '113.585729,23.547820',\n",
       "    'address': '新城东路80号一、二层',\n",
       "    'poiweight': '0.514928',\n",
       "    'businessarea': '街口'},\n",
       "   {'id': 'B0FFG7J09R',\n",
       "    'name': '从化区综治信访维稳中心',\n",
       "    'type': '政府机构及社会团体;政府机关;区县级政府及事业单位',\n",
       "    'tel': '020-87928733',\n",
       "    'direction': '东南',\n",
       "    'distance': '84.9475',\n",
       "    'location': '113.587181,23.548300',\n",
       "    'address': '新城东路99',\n",
       "    'poiweight': '0.169373',\n",
       "    'businessarea': '街口'},\n",
       "   {'id': 'B0FFF3UQW3',\n",
       "    'name': '明师教育从化新世纪上课点',\n",
       "    'type': '科教文化服务;培训机构;培训机构',\n",
       "    'tel': '020-87957748',\n",
       "    'direction': '东南',\n",
       "    'distance': '135.505',\n",
       "    'location': '113.587312,23.547820',\n",
       "    'address': '街口镇新城东路68-1号(肯德基对面)',\n",
       "    'poiweight': '0.140757',\n",
       "    'businessarea': '街口'},\n",
       "   {'id': 'B0FFGJ24CK',\n",
       "    'name': '广州市从化区国防动员委员会',\n",
       "    'type': '政府机构及社会团体;政府机关;区县级政府及事业单位',\n",
       "    'tel': [],\n",
       "    'direction': '南',\n",
       "    'distance': '21.3686',\n",
       "    'location': '113.586615,23.548660',\n",
       "    'address': '新城东路99',\n",
       "    'poiweight': '0.165926',\n",
       "    'businessarea': '街口'},\n",
       "   {'id': 'B0FFF3UNTN',\n",
       "    'name': '东科商务·富逸财富港',\n",
       "    'type': '商务住宅;楼宇;商务写字楼',\n",
       "    'tel': '13725145988',\n",
       "    'direction': '西南',\n",
       "    'distance': '182.033',\n",
       "    'location': '113.585527,23.547547',\n",
       "    'address': '新城东路80-12',\n",
       "    'poiweight': '0.26943',\n",
       "    'businessarea': '街口'},\n",
       "   {'id': 'B00140UGAP',\n",
       "    'name': '林苑大厦(新城东路)',\n",
       "    'type': '商务住宅;楼宇;商务写字楼',\n",
       "    'tel': [],\n",
       "    'direction': '东南',\n",
       "    'distance': '188.329',\n",
       "    'location': '113.587891,23.547636',\n",
       "    'address': '新城东路68号',\n",
       "    'poiweight': '0.344929',\n",
       "    'businessarea': '街口'},\n",
       "   {'id': 'B0FFF3UW5K',\n",
       "    'name': '从化区创建平安工作领导小组办公室',\n",
       "    'type': '政府机构及社会团体;政府机关;区县级政府及事业单位',\n",
       "    'tel': [],\n",
       "    'direction': '西',\n",
       "    'distance': '106.187',\n",
       "    'location': '113.585646,23.548479',\n",
       "    'address': '新城中路7-9号附近',\n",
       "    'poiweight': '0.170039',\n",
       "    'businessarea': '街口'},\n",
       "   {'id': 'B00140J9N4',\n",
       "    'name': '从化区文化市场综合行政执法队',\n",
       "    'type': '政府机构及社会团体;政府机关;区县级政府及事业单位',\n",
       "    'tel': [],\n",
       "    'direction': '西',\n",
       "    'distance': '148.352',\n",
       "    'location': '113.585177,23.549109',\n",
       "    'address': '新城中路39',\n",
       "    'poiweight': '0.141105',\n",
       "    'businessarea': '街口'},\n",
       "   {'id': 'B00140MIC9',\n",
       "    'name': '从化商业幼儿园',\n",
       "    'type': '科教文化服务;学校;幼儿园',\n",
       "    'tel': '020-87922390',\n",
       "    'direction': '北',\n",
       "    'distance': '189.626',\n",
       "    'location': '113.586572,23.550557',\n",
       "    'address': '西宁中路',\n",
       "    'poiweight': '0.205589',\n",
       "    'businessarea': '街口'},\n",
       "   {'id': 'B00140NPDY',\n",
       "    'name': '新村居委会社区退休职工管理服务站',\n",
       "    'type': '政府机构及社会团体;政府机关;乡镇以下级政府及事业单位',\n",
       "    'tel': [],\n",
       "    'direction': '北',\n",
       "    'distance': '171.308',\n",
       "    'location': '113.586213,23.550350',\n",
       "    'address': '西宁中路148号之3附近',\n",
       "    'poiweight': '0.123706',\n",
       "    'businessarea': '街口'},\n",
       "   {'id': 'B00140NETK',\n",
       "    'name': '新村社区居委会(西宁中路五巷)',\n",
       "    'type': '政府机构及社会团体;政府机关;乡镇以下级政府及事业单位',\n",
       "    'tel': '020-87935109',\n",
       "    'direction': '西北',\n",
       "    'distance': '189.905',\n",
       "    'location': '113.585741,23.550365',\n",
       "    'address': '新村东路61-1',\n",
       "    'poiweight': '0.404627',\n",
       "    'businessarea': '街口'},\n",
       "   {'id': 'B00140NTQ0',\n",
       "    'name': '中共新村社区支部委员会(西宁中路五巷)',\n",
       "    'type': '政府机构及社会团体;政府机关;乡镇以下级政府及事业单位',\n",
       "    'tel': [],\n",
       "    'direction': '西北',\n",
       "    'distance': '189.905',\n",
       "    'location': '113.585741,23.550365',\n",
       "    'address': '新村路60号',\n",
       "    'poiweight': '0.134518',\n",
       "    'businessarea': '街口'},\n",
       "   {'id': 'B00141ID88',\n",
       "    'name': '富逸华庭',\n",
       "    'type': '商务住宅;住宅区;住宅小区',\n",
       "    'tel': [],\n",
       "    'direction': '西南',\n",
       "    'distance': '142.175',\n",
       "    'location': '113.586068,23.547672',\n",
       "    'address': '新城东路80号',\n",
       "    'poiweight': '0.348063',\n",
       "    'businessarea': '街口'},\n",
       "   {'id': 'B00141RB6B',\n",
       "    'name': '东华里',\n",
       "    'type': '商务住宅;住宅区;住宅小区',\n",
       "    'tel': [],\n",
       "    'direction': '西',\n",
       "    'distance': '179.954',\n",
       "    'location': '113.584868,23.548563',\n",
       "    'address': '新城中路10号',\n",
       "    'poiweight': '0.367551',\n",
       "    'businessarea': '街口'},\n",
       "   {'id': 'B0FFF32RLG',\n",
       "    'name': '从化区人事局',\n",
       "    'type': '政府机构及社会团体;政府机关;政府机关相关',\n",
       "    'tel': '020-87922814',\n",
       "    'direction': '南',\n",
       "    'distance': '59.3667',\n",
       "    'location': '113.586410,23.548349',\n",
       "    'address': '新城东路99号',\n",
       "    'poiweight': '0.11745',\n",
       "    'businessarea': '街口'},\n",
       "   {'id': 'B0FFF2N8SM',\n",
       "    'name': '从化区监察局',\n",
       "    'type': '政府机构及社会团体;政府机关;政府机关相关',\n",
       "    'tel': [],\n",
       "    'direction': '西南',\n",
       "    'distance': '72.9685',\n",
       "    'location': '113.586272,23.548271',\n",
       "    'address': '新城东路99号',\n",
       "    'poiweight': '0.11745',\n",
       "    'businessarea': '街口'},\n",
       "   {'id': 'B001408643',\n",
       "    'name': '从化区人民政府招待所',\n",
       "    'type': '住宿服务;旅馆招待所;旅馆招待所',\n",
       "    'tel': '020-87922022',\n",
       "    'direction': '东',\n",
       "    'distance': '108.333',\n",
       "    'location': '113.587615,23.549155',\n",
       "    'address': '街口街西宁横街75号',\n",
       "    'poiweight': '0.360069',\n",
       "    'businessarea': '街口'},\n",
       "   {'id': 'B00140TWK0',\n",
       "    'name': '肯德基甜品站(新世纪店)',\n",
       "    'type': '餐饮服务;快餐厅;肯德基',\n",
       "    'tel': '020-87939871;020-87939891',\n",
       "    'direction': '东南',\n",
       "    'distance': '180.896',\n",
       "    'location': '113.587847,23.547690',\n",
       "    'address': '新城东路66号林苑大厦1-2层',\n",
       "    'poiweight': '0.355148',\n",
       "    'businessarea': '街口'},\n",
       "   {'id': 'B0H6DUBGQ5',\n",
       "    'name': '城悦旅馆',\n",
       "    'type': '住宿服务;旅馆招待所;旅馆招待所',\n",
       "    'tel': '020-87930209;13798058272',\n",
       "    'direction': '西',\n",
       "    'distance': '183.527',\n",
       "    'location': '113.584900,23.549382',\n",
       "    'address': '新城中路41号(广播电视器材站旁)',\n",
       "    'poiweight': '0.27959',\n",
       "    'businessarea': '街口'},\n",
       "   {'id': 'B00141KB1H',\n",
       "    'name': '秋田菊寿司料理',\n",
       "    'type': '餐饮服务;外国餐厅;日本料理',\n",
       "    'tel': '13602412074',\n",
       "    'direction': '东南',\n",
       "    'distance': '111.003',\n",
       "    'location': '113.587545,23.548348',\n",
       "    'address': '街口街新城东路荔香村4栋104、107号',\n",
       "    'poiweight': '0.126091',\n",
       "    'businessarea': '街口'},\n",
       "   {'id': 'B0FFG6TUIH',\n",
       "    'name': '从化区广播电视台城区鳌头广播电视站工会委员会',\n",
       "    'type': '政府机构及社会团体;社会团体;社会团体相关',\n",
       "    'tel': [],\n",
       "    'direction': '西',\n",
       "    'distance': '150.339',\n",
       "    'location': '113.585165,23.549144',\n",
       "    'address': '新城中路39',\n",
       "    'poiweight': '0.147889',\n",
       "    'businessarea': '街口'}],\n",
       "  'roads': [{'id': '020F49F0060454023',\n",
       "    'name': '新城东路',\n",
       "    'direction': '北',\n",
       "    'distance': '81.3964',\n",
       "    'location': '113.587,23.5481'},\n",
       "   {'id': '020F49F006045608841',\n",
       "    'name': '新城东路六巷',\n",
       "    'direction': '北',\n",
       "    'distance': '92.921',\n",
       "    'location': '113.587,23.548'},\n",
       "   {'id': '020F49F006045614615',\n",
       "    'name': '新城东七巷',\n",
       "    'direction': '东北',\n",
       "    'distance': '101.004',\n",
       "    'location': '113.586,23.548'}],\n",
       "  'roadinters': [{'direction': '东北',\n",
       "    'distance': '101.004',\n",
       "    'location': '113.586194,23.548025',\n",
       "    'first_id': '020F49F0060454023',\n",
       "    'first_name': '新城东路',\n",
       "    'second_id': '020F49F006045614615',\n",
       "    'second_name': '新城东七巷'}],\n",
       "  'aois': []}}"
      ]
     },
     "execution_count": 24,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "r.json()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 29,
   "id": "89987bd3",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>id</th>\n",
       "      <th>name</th>\n",
       "      <th>type</th>\n",
       "      <th>tel</th>\n",
       "      <th>direction</th>\n",
       "      <th>distance</th>\n",
       "      <th>location</th>\n",
       "      <th>address</th>\n",
       "      <th>poiweight</th>\n",
       "      <th>businessarea</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>B00140MR5X</td>\n",
       "      <td>中国银行(广州从化支行)</td>\n",
       "      <td>金融保险服务;银行;中国银行</td>\n",
       "      <td>020-87929678;020-87923974</td>\n",
       "      <td>南</td>\n",
       "      <td>103.541</td>\n",
       "      <td>113.586937,23.547972</td>\n",
       "      <td>街口镇新城东路74号</td>\n",
       "      <td>0.374805</td>\n",
       "      <td>街口</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>B0FFGJ24FS</td>\n",
       "      <td>从化区人大常委会</td>\n",
       "      <td>政府机构及社会团体;政府机关;区县级政府及事业单位</td>\n",
       "      <td>020-87926111</td>\n",
       "      <td>东南</td>\n",
       "      <td>13.791</td>\n",
       "      <td>113.586679,23.548748</td>\n",
       "      <td>街口街道新城东路99号大院内</td>\n",
       "      <td>0.165926</td>\n",
       "      <td>街口</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>B0FFGJ24FT</td>\n",
       "      <td>从化区政协</td>\n",
       "      <td>政府机构及社会团体;政府机关;区县级政府及事业单位</td>\n",
       "      <td>020-87922613</td>\n",
       "      <td>东南</td>\n",
       "      <td>13.791</td>\n",
       "      <td>113.586679,23.548748</td>\n",
       "      <td>新城东路99</td>\n",
       "      <td>0.165926</td>\n",
       "      <td>街口</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>B0014072CF</td>\n",
       "      <td>广州市从化区人民政府</td>\n",
       "      <td>政府机构及社会团体;政府机关;区县级政府及事业单位</td>\n",
       "      <td>020-87928410;020-87922712</td>\n",
       "      <td>南</td>\n",
       "      <td>66.6705</td>\n",
       "      <td>113.586405,23.548281</td>\n",
       "      <td>新城东路99号</td>\n",
       "      <td>0.529579</td>\n",
       "      <td>街口</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>B00141PSGY</td>\n",
       "      <td>从化区委组织部</td>\n",
       "      <td>政府机构及社会团体;政府机关;区县级政府及事业单位</td>\n",
       "      <td>020-87922092</td>\n",
       "      <td>西南</td>\n",
       "      <td>0.66843</td>\n",
       "      <td>113.586600,23.548848</td>\n",
       "      <td>街口街新城东路99号</td>\n",
       "      <td>0.245493</td>\n",
       "      <td>街口</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>B00141PSC0</td>\n",
       "      <td>从化区委宣传部</td>\n",
       "      <td>政府机构及社会团体;政府机关;区县级政府及事业单位</td>\n",
       "      <td>020-87922221</td>\n",
       "      <td>西南</td>\n",
       "      <td>0.66843</td>\n",
       "      <td>113.586600,23.548848</td>\n",
       "      <td>街口街新城东路99号</td>\n",
       "      <td>0.249396</td>\n",
       "      <td>街口</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>B0FFGJ24ZR</td>\n",
       "      <td>中共广州市从化区委员会</td>\n",
       "      <td>政府机构及社会团体;政府机关;区县级政府及事业单位</td>\n",
       "      <td>[]</td>\n",
       "      <td>东南</td>\n",
       "      <td>13.791</td>\n",
       "      <td>113.586679,23.548748</td>\n",
       "      <td>新城东路99</td>\n",
       "      <td>0.165926</td>\n",
       "      <td>街口</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>B00140ICZY</td>\n",
       "      <td>中心会堂</td>\n",
       "      <td>科教文化服务;会展中心;会展中心</td>\n",
       "      <td>[]</td>\n",
       "      <td>东南</td>\n",
       "      <td>0.532943</td>\n",
       "      <td>113.586608,23.548848</td>\n",
       "      <td>新城东路99</td>\n",
       "      <td>0.276118</td>\n",
       "      <td>街口</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>B00140V14Y</td>\n",
       "      <td>国美电器(从化店)</td>\n",
       "      <td>购物服务;家电电子卖场;国美</td>\n",
       "      <td>020-37939789</td>\n",
       "      <td>东</td>\n",
       "      <td>129.768</td>\n",
       "      <td>113.587771,23.548384</td>\n",
       "      <td>街口街荔香村1期1-3栋2层</td>\n",
       "      <td>0.287666</td>\n",
       "      <td>街口</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>B00140MJ8Z</td>\n",
       "      <td>苏宁易购(从化街口路店)</td>\n",
       "      <td>购物服务;家电电子卖场;苏宁</td>\n",
       "      <td>19902230595</td>\n",
       "      <td>西南</td>\n",
       "      <td>145.411</td>\n",
       "      <td>113.585729,23.547820</td>\n",
       "      <td>新城东路80号一、二层</td>\n",
       "      <td>0.514928</td>\n",
       "      <td>街口</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>B0FFG7J09R</td>\n",
       "      <td>从化区综治信访维稳中心</td>\n",
       "      <td>政府机构及社会团体;政府机关;区县级政府及事业单位</td>\n",
       "      <td>020-87928733</td>\n",
       "      <td>东南</td>\n",
       "      <td>84.9475</td>\n",
       "      <td>113.587181,23.548300</td>\n",
       "      <td>新城东路99</td>\n",
       "      <td>0.169373</td>\n",
       "      <td>街口</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>B0FFF3UQW3</td>\n",
       "      <td>明师教育从化新世纪上课点</td>\n",
       "      <td>科教文化服务;培训机构;培训机构</td>\n",
       "      <td>020-87957748</td>\n",
       "      <td>东南</td>\n",
       "      <td>135.505</td>\n",
       "      <td>113.587312,23.547820</td>\n",
       "      <td>街口镇新城东路68-1号(肯德基对面)</td>\n",
       "      <td>0.140757</td>\n",
       "      <td>街口</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>B0FFGJ24CK</td>\n",
       "      <td>广州市从化区国防动员委员会</td>\n",
       "      <td>政府机构及社会团体;政府机关;区县级政府及事业单位</td>\n",
       "      <td>[]</td>\n",
       "      <td>南</td>\n",
       "      <td>21.3686</td>\n",
       "      <td>113.586615,23.548660</td>\n",
       "      <td>新城东路99</td>\n",
       "      <td>0.165926</td>\n",
       "      <td>街口</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>B0FFF3UNTN</td>\n",
       "      <td>东科商务·富逸财富港</td>\n",
       "      <td>商务住宅;楼宇;商务写字楼</td>\n",
       "      <td>13725145988</td>\n",
       "      <td>西南</td>\n",
       "      <td>182.033</td>\n",
       "      <td>113.585527,23.547547</td>\n",
       "      <td>新城东路80-12</td>\n",
       "      <td>0.26943</td>\n",
       "      <td>街口</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>B00140UGAP</td>\n",
       "      <td>林苑大厦(新城东路)</td>\n",
       "      <td>商务住宅;楼宇;商务写字楼</td>\n",
       "      <td>[]</td>\n",
       "      <td>东南</td>\n",
       "      <td>188.329</td>\n",
       "      <td>113.587891,23.547636</td>\n",
       "      <td>新城东路68号</td>\n",
       "      <td>0.344929</td>\n",
       "      <td>街口</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>B0FFF3UW5K</td>\n",
       "      <td>从化区创建平安工作领导小组办公室</td>\n",
       "      <td>政府机构及社会团体;政府机关;区县级政府及事业单位</td>\n",
       "      <td>[]</td>\n",
       "      <td>西</td>\n",
       "      <td>106.187</td>\n",
       "      <td>113.585646,23.548479</td>\n",
       "      <td>新城中路7-9号附近</td>\n",
       "      <td>0.170039</td>\n",
       "      <td>街口</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>B00140J9N4</td>\n",
       "      <td>从化区文化市场综合行政执法队</td>\n",
       "      <td>政府机构及社会团体;政府机关;区县级政府及事业单位</td>\n",
       "      <td>[]</td>\n",
       "      <td>西</td>\n",
       "      <td>148.352</td>\n",
       "      <td>113.585177,23.549109</td>\n",
       "      <td>新城中路39</td>\n",
       "      <td>0.141105</td>\n",
       "      <td>街口</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>B00140MIC9</td>\n",
       "      <td>从化商业幼儿园</td>\n",
       "      <td>科教文化服务;学校;幼儿园</td>\n",
       "      <td>020-87922390</td>\n",
       "      <td>北</td>\n",
       "      <td>189.626</td>\n",
       "      <td>113.586572,23.550557</td>\n",
       "      <td>西宁中路</td>\n",
       "      <td>0.205589</td>\n",
       "      <td>街口</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>B00140NPDY</td>\n",
       "      <td>新村居委会社区退休职工管理服务站</td>\n",
       "      <td>政府机构及社会团体;政府机关;乡镇以下级政府及事业单位</td>\n",
       "      <td>[]</td>\n",
       "      <td>北</td>\n",
       "      <td>171.308</td>\n",
       "      <td>113.586213,23.550350</td>\n",
       "      <td>西宁中路148号之3附近</td>\n",
       "      <td>0.123706</td>\n",
       "      <td>街口</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>B00140NETK</td>\n",
       "      <td>新村社区居委会(西宁中路五巷)</td>\n",
       "      <td>政府机构及社会团体;政府机关;乡镇以下级政府及事业单位</td>\n",
       "      <td>020-87935109</td>\n",
       "      <td>西北</td>\n",
       "      <td>189.905</td>\n",
       "      <td>113.585741,23.550365</td>\n",
       "      <td>新村东路61-1</td>\n",
       "      <td>0.404627</td>\n",
       "      <td>街口</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>B00140NTQ0</td>\n",
       "      <td>中共新村社区支部委员会(西宁中路五巷)</td>\n",
       "      <td>政府机构及社会团体;政府机关;乡镇以下级政府及事业单位</td>\n",
       "      <td>[]</td>\n",
       "      <td>西北</td>\n",
       "      <td>189.905</td>\n",
       "      <td>113.585741,23.550365</td>\n",
       "      <td>新村路60号</td>\n",
       "      <td>0.134518</td>\n",
       "      <td>街口</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>B00141ID88</td>\n",
       "      <td>富逸华庭</td>\n",
       "      <td>商务住宅;住宅区;住宅小区</td>\n",
       "      <td>[]</td>\n",
       "      <td>西南</td>\n",
       "      <td>142.175</td>\n",
       "      <td>113.586068,23.547672</td>\n",
       "      <td>新城东路80号</td>\n",
       "      <td>0.348063</td>\n",
       "      <td>街口</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>B00141RB6B</td>\n",
       "      <td>东华里</td>\n",
       "      <td>商务住宅;住宅区;住宅小区</td>\n",
       "      <td>[]</td>\n",
       "      <td>西</td>\n",
       "      <td>179.954</td>\n",
       "      <td>113.584868,23.548563</td>\n",
       "      <td>新城中路10号</td>\n",
       "      <td>0.367551</td>\n",
       "      <td>街口</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>B0FFF32RLG</td>\n",
       "      <td>从化区人事局</td>\n",
       "      <td>政府机构及社会团体;政府机关;政府机关相关</td>\n",
       "      <td>020-87922814</td>\n",
       "      <td>南</td>\n",
       "      <td>59.3667</td>\n",
       "      <td>113.586410,23.548349</td>\n",
       "      <td>新城东路99号</td>\n",
       "      <td>0.11745</td>\n",
       "      <td>街口</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>B0FFF2N8SM</td>\n",
       "      <td>从化区监察局</td>\n",
       "      <td>政府机构及社会团体;政府机关;政府机关相关</td>\n",
       "      <td>[]</td>\n",
       "      <td>西南</td>\n",
       "      <td>72.9685</td>\n",
       "      <td>113.586272,23.548271</td>\n",
       "      <td>新城东路99号</td>\n",
       "      <td>0.11745</td>\n",
       "      <td>街口</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>B001408643</td>\n",
       "      <td>从化区人民政府招待所</td>\n",
       "      <td>住宿服务;旅馆招待所;旅馆招待所</td>\n",
       "      <td>020-87922022</td>\n",
       "      <td>东</td>\n",
       "      <td>108.333</td>\n",
       "      <td>113.587615,23.549155</td>\n",
       "      <td>街口街西宁横街75号</td>\n",
       "      <td>0.360069</td>\n",
       "      <td>街口</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>B00140TWK0</td>\n",
       "      <td>肯德基甜品站(新世纪店)</td>\n",
       "      <td>餐饮服务;快餐厅;肯德基</td>\n",
       "      <td>020-87939871;020-87939891</td>\n",
       "      <td>东南</td>\n",
       "      <td>180.896</td>\n",
       "      <td>113.587847,23.547690</td>\n",
       "      <td>新城东路66号林苑大厦1-2层</td>\n",
       "      <td>0.355148</td>\n",
       "      <td>街口</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>B0H6DUBGQ5</td>\n",
       "      <td>城悦旅馆</td>\n",
       "      <td>住宿服务;旅馆招待所;旅馆招待所</td>\n",
       "      <td>020-87930209;13798058272</td>\n",
       "      <td>西</td>\n",
       "      <td>183.527</td>\n",
       "      <td>113.584900,23.549382</td>\n",
       "      <td>新城中路41号(广播电视器材站旁)</td>\n",
       "      <td>0.27959</td>\n",
       "      <td>街口</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>B00141KB1H</td>\n",
       "      <td>秋田菊寿司料理</td>\n",
       "      <td>餐饮服务;外国餐厅;日本料理</td>\n",
       "      <td>13602412074</td>\n",
       "      <td>东南</td>\n",
       "      <td>111.003</td>\n",
       "      <td>113.587545,23.548348</td>\n",
       "      <td>街口街新城东路荔香村4栋104、107号</td>\n",
       "      <td>0.126091</td>\n",
       "      <td>街口</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>B0FFG6TUIH</td>\n",
       "      <td>从化区广播电视台城区鳌头广播电视站工会委员会</td>\n",
       "      <td>政府机构及社会团体;社会团体;社会团体相关</td>\n",
       "      <td>[]</td>\n",
       "      <td>西</td>\n",
       "      <td>150.339</td>\n",
       "      <td>113.585165,23.549144</td>\n",
       "      <td>新城中路39</td>\n",
       "      <td>0.147889</td>\n",
       "      <td>街口</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "            id                    name                         type  \\\n",
       "0   B00140MR5X            中国银行(广州从化支行)               金融保险服务;银行;中国银行   \n",
       "1   B0FFGJ24FS                从化区人大常委会    政府机构及社会团体;政府机关;区县级政府及事业单位   \n",
       "2   B0FFGJ24FT                   从化区政协    政府机构及社会团体;政府机关;区县级政府及事业单位   \n",
       "3   B0014072CF              广州市从化区人民政府    政府机构及社会团体;政府机关;区县级政府及事业单位   \n",
       "4   B00141PSGY                 从化区委组织部    政府机构及社会团体;政府机关;区县级政府及事业单位   \n",
       "5   B00141PSC0                 从化区委宣传部    政府机构及社会团体;政府机关;区县级政府及事业单位   \n",
       "6   B0FFGJ24ZR             中共广州市从化区委员会    政府机构及社会团体;政府机关;区县级政府及事业单位   \n",
       "7   B00140ICZY                    中心会堂             科教文化服务;会展中心;会展中心   \n",
       "8   B00140V14Y               国美电器(从化店)               购物服务;家电电子卖场;国美   \n",
       "9   B00140MJ8Z            苏宁易购(从化街口路店)               购物服务;家电电子卖场;苏宁   \n",
       "10  B0FFG7J09R             从化区综治信访维稳中心    政府机构及社会团体;政府机关;区县级政府及事业单位   \n",
       "11  B0FFF3UQW3            明师教育从化新世纪上课点             科教文化服务;培训机构;培训机构   \n",
       "12  B0FFGJ24CK           广州市从化区国防动员委员会    政府机构及社会团体;政府机关;区县级政府及事业单位   \n",
       "13  B0FFF3UNTN              东科商务·富逸财富港                商务住宅;楼宇;商务写字楼   \n",
       "14  B00140UGAP              林苑大厦(新城东路)                商务住宅;楼宇;商务写字楼   \n",
       "15  B0FFF3UW5K        从化区创建平安工作领导小组办公室    政府机构及社会团体;政府机关;区县级政府及事业单位   \n",
       "16  B00140J9N4          从化区文化市场综合行政执法队    政府机构及社会团体;政府机关;区县级政府及事业单位   \n",
       "17  B00140MIC9                 从化商业幼儿园                科教文化服务;学校;幼儿园   \n",
       "18  B00140NPDY        新村居委会社区退休职工管理服务站  政府机构及社会团体;政府机关;乡镇以下级政府及事业单位   \n",
       "19  B00140NETK         新村社区居委会(西宁中路五巷)  政府机构及社会团体;政府机关;乡镇以下级政府及事业单位   \n",
       "20  B00140NTQ0     中共新村社区支部委员会(西宁中路五巷)  政府机构及社会团体;政府机关;乡镇以下级政府及事业单位   \n",
       "21  B00141ID88                    富逸华庭                商务住宅;住宅区;住宅小区   \n",
       "22  B00141RB6B                     东华里                商务住宅;住宅区;住宅小区   \n",
       "23  B0FFF32RLG                  从化区人事局        政府机构及社会团体;政府机关;政府机关相关   \n",
       "24  B0FFF2N8SM                  从化区监察局        政府机构及社会团体;政府机关;政府机关相关   \n",
       "25  B001408643              从化区人民政府招待所             住宿服务;旅馆招待所;旅馆招待所   \n",
       "26  B00140TWK0            肯德基甜品站(新世纪店)                 餐饮服务;快餐厅;肯德基   \n",
       "27  B0H6DUBGQ5                    城悦旅馆             住宿服务;旅馆招待所;旅馆招待所   \n",
       "28  B00141KB1H                 秋田菊寿司料理               餐饮服务;外国餐厅;日本料理   \n",
       "29  B0FFG6TUIH  从化区广播电视台城区鳌头广播电视站工会委员会        政府机构及社会团体;社会团体;社会团体相关   \n",
       "\n",
       "                          tel direction  distance              location  \\\n",
       "0   020-87929678;020-87923974         南   103.541  113.586937,23.547972   \n",
       "1                020-87926111        东南    13.791  113.586679,23.548748   \n",
       "2                020-87922613        东南    13.791  113.586679,23.548748   \n",
       "3   020-87928410;020-87922712         南   66.6705  113.586405,23.548281   \n",
       "4                020-87922092        西南   0.66843  113.586600,23.548848   \n",
       "5                020-87922221        西南   0.66843  113.586600,23.548848   \n",
       "6                          []        东南    13.791  113.586679,23.548748   \n",
       "7                          []        东南  0.532943  113.586608,23.548848   \n",
       "8                020-37939789         东   129.768  113.587771,23.548384   \n",
       "9                 19902230595        西南   145.411  113.585729,23.547820   \n",
       "10               020-87928733        东南   84.9475  113.587181,23.548300   \n",
       "11               020-87957748        东南   135.505  113.587312,23.547820   \n",
       "12                         []         南   21.3686  113.586615,23.548660   \n",
       "13                13725145988        西南   182.033  113.585527,23.547547   \n",
       "14                         []        东南   188.329  113.587891,23.547636   \n",
       "15                         []         西   106.187  113.585646,23.548479   \n",
       "16                         []         西   148.352  113.585177,23.549109   \n",
       "17               020-87922390         北   189.626  113.586572,23.550557   \n",
       "18                         []         北   171.308  113.586213,23.550350   \n",
       "19               020-87935109        西北   189.905  113.585741,23.550365   \n",
       "20                         []        西北   189.905  113.585741,23.550365   \n",
       "21                         []        西南   142.175  113.586068,23.547672   \n",
       "22                         []         西   179.954  113.584868,23.548563   \n",
       "23               020-87922814         南   59.3667  113.586410,23.548349   \n",
       "24                         []        西南   72.9685  113.586272,23.548271   \n",
       "25               020-87922022         东   108.333  113.587615,23.549155   \n",
       "26  020-87939871;020-87939891        东南   180.896  113.587847,23.547690   \n",
       "27   020-87930209;13798058272         西   183.527  113.584900,23.549382   \n",
       "28                13602412074        东南   111.003  113.587545,23.548348   \n",
       "29                         []         西   150.339  113.585165,23.549144   \n",
       "\n",
       "                 address poiweight businessarea  \n",
       "0             街口镇新城东路74号  0.374805           街口  \n",
       "1         街口街道新城东路99号大院内  0.165926           街口  \n",
       "2                 新城东路99  0.165926           街口  \n",
       "3                新城东路99号  0.529579           街口  \n",
       "4             街口街新城东路99号  0.245493           街口  \n",
       "5             街口街新城东路99号  0.249396           街口  \n",
       "6                 新城东路99  0.165926           街口  \n",
       "7                 新城东路99  0.276118           街口  \n",
       "8         街口街荔香村1期1-3栋2层  0.287666           街口  \n",
       "9            新城东路80号一、二层  0.514928           街口  \n",
       "10                新城东路99  0.169373           街口  \n",
       "11   街口镇新城东路68-1号(肯德基对面)  0.140757           街口  \n",
       "12                新城东路99  0.165926           街口  \n",
       "13             新城东路80-12   0.26943           街口  \n",
       "14               新城东路68号  0.344929           街口  \n",
       "15            新城中路7-9号附近  0.170039           街口  \n",
       "16                新城中路39  0.141105           街口  \n",
       "17                  西宁中路  0.205589           街口  \n",
       "18          西宁中路148号之3附近  0.123706           街口  \n",
       "19              新村东路61-1  0.404627           街口  \n",
       "20                新村路60号  0.134518           街口  \n",
       "21               新城东路80号  0.348063           街口  \n",
       "22               新城中路10号  0.367551           街口  \n",
       "23               新城东路99号   0.11745           街口  \n",
       "24               新城东路99号   0.11745           街口  \n",
       "25            街口街西宁横街75号  0.360069           街口  \n",
       "26       新城东路66号林苑大厦1-2层  0.355148           街口  \n",
       "27     新城中路41号(广播电视器材站旁)   0.27959           街口  \n",
       "28  街口街新城东路荔香村4栋104、107号  0.126091           街口  \n",
       "29                新城中路39  0.147889           街口  "
      ]
     },
     "execution_count": 29,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import pandas as pd\n",
    "pd.json_normalize(r.json()['regeocode']['pois'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 33,
   "id": "aa2bb962",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 34,
   "id": "5b623dc8",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "{'status': '1',\n",
       " 'info': 'OK',\n",
       " 'infocode': '10000',\n",
       " 'regeocode': {'formatted_address': '广东省广州市从化区街口街道中心会堂',\n",
       "  'addressComponent': {'country': '中国',\n",
       "   'province': '广东省',\n",
       "   'city': '广州市',\n",
       "   'citycode': '020',\n",
       "   'district': '从化区',\n",
       "   'adcode': '440117',\n",
       "   'township': '街口街道',\n",
       "   'towncode': '440117001000',\n",
       "   'neighborhood': {'name': [], 'type': []},\n",
       "   'building': {'name': [], 'type': []},\n",
       "   'streetNumber': {'street': '新城东路',\n",
       "    'number': '99号',\n",
       "    'location': '113.586615,23.548660',\n",
       "    'direction': '南',\n",
       "    'distance': '21.3686'},\n",
       "   'businessAreas': [{'location': '113.586019,23.546975',\n",
       "     'name': '街口',\n",
       "     'id': '440117'},\n",
       "    {'location': '113.568684,23.563922', 'name': '城郊', 'id': '440117'},\n",
       "    {'location': '113.604074,23.533964', 'name': '江埔', 'id': '440117'}]},\n",
       "  'pois': [{'id': 'B00140MR5X',\n",
       "    'name': '中国银行(广州从化支行)',\n",
       "    'type': '金融保险服务;银行;中国银行',\n",
       "    'tel': '020-87929678;020-87923974',\n",
       "    'direction': '南',\n",
       "    'distance': '103.541',\n",
       "    'location': '113.586937,23.547972',\n",
       "    'address': '街口镇新城东路74号',\n",
       "    'poiweight': '0.374805',\n",
       "    'businessarea': '街口'},\n",
       "   {'id': 'B0FFGJ24FS',\n",
       "    'name': '从化区人大常委会',\n",
       "    'type': '政府机构及社会团体;政府机关;区县级政府及事业单位',\n",
       "    'tel': '020-87926111',\n",
       "    'direction': '东南',\n",
       "    'distance': '13.791',\n",
       "    'location': '113.586679,23.548748',\n",
       "    'address': '街口街道新城东路99号大院内',\n",
       "    'poiweight': '0.165926',\n",
       "    'businessarea': '街口'},\n",
       "   {'id': 'B0FFGJ24FT',\n",
       "    'name': '从化区政协',\n",
       "    'type': '政府机构及社会团体;政府机关;区县级政府及事业单位',\n",
       "    'tel': '020-87922613',\n",
       "    'direction': '东南',\n",
       "    'distance': '13.791',\n",
       "    'location': '113.586679,23.548748',\n",
       "    'address': '新城东路99',\n",
       "    'poiweight': '0.165926',\n",
       "    'businessarea': '街口'},\n",
       "   {'id': 'B0014072CF',\n",
       "    'name': '广州市从化区人民政府',\n",
       "    'type': '政府机构及社会团体;政府机关;区县级政府及事业单位',\n",
       "    'tel': '020-87928410;020-87922712',\n",
       "    'direction': '南',\n",
       "    'distance': '66.6705',\n",
       "    'location': '113.586405,23.548281',\n",
       "    'address': '新城东路99号',\n",
       "    'poiweight': '0.529579',\n",
       "    'businessarea': '街口'},\n",
       "   {'id': 'B00141PSGY',\n",
       "    'name': '从化区委组织部',\n",
       "    'type': '政府机构及社会团体;政府机关;区县级政府及事业单位',\n",
       "    'tel': '020-87922092',\n",
       "    'direction': '西南',\n",
       "    'distance': '0.66843',\n",
       "    'location': '113.586600,23.548848',\n",
       "    'address': '街口街新城东路99号',\n",
       "    'poiweight': '0.245493',\n",
       "    'businessarea': '街口'},\n",
       "   {'id': 'B00141PSC0',\n",
       "    'name': '从化区委宣传部',\n",
       "    'type': '政府机构及社会团体;政府机关;区县级政府及事业单位',\n",
       "    'tel': '020-87922221',\n",
       "    'direction': '西南',\n",
       "    'distance': '0.66843',\n",
       "    'location': '113.586600,23.548848',\n",
       "    'address': '街口街新城东路99号',\n",
       "    'poiweight': '0.249396',\n",
       "    'businessarea': '街口'},\n",
       "   {'id': 'B0FFGJ24ZR',\n",
       "    'name': '中共广州市从化区委员会',\n",
       "    'type': '政府机构及社会团体;政府机关;区县级政府及事业单位',\n",
       "    'tel': [],\n",
       "    'direction': '东南',\n",
       "    'distance': '13.791',\n",
       "    'location': '113.586679,23.548748',\n",
       "    'address': '新城东路99',\n",
       "    'poiweight': '0.165926',\n",
       "    'businessarea': '街口'},\n",
       "   {'id': 'B00140ICZY',\n",
       "    'name': '中心会堂',\n",
       "    'type': '科教文化服务;会展中心;会展中心',\n",
       "    'tel': [],\n",
       "    'direction': '东南',\n",
       "    'distance': '0.532943',\n",
       "    'location': '113.586608,23.548848',\n",
       "    'address': '新城东路99',\n",
       "    'poiweight': '0.276118',\n",
       "    'businessarea': '街口'},\n",
       "   {'id': 'B00140V14Y',\n",
       "    'name': '国美电器(从化店)',\n",
       "    'type': '购物服务;家电电子卖场;国美',\n",
       "    'tel': '020-37939789',\n",
       "    'direction': '东',\n",
       "    'distance': '129.768',\n",
       "    'location': '113.587771,23.548384',\n",
       "    'address': '街口街荔香村1期1-3栋2层',\n",
       "    'poiweight': '0.287666',\n",
       "    'businessarea': '街口'},\n",
       "   {'id': 'B00140MJ8Z',\n",
       "    'name': '苏宁易购(从化街口路店)',\n",
       "    'type': '购物服务;家电电子卖场;苏宁',\n",
       "    'tel': '19902230595',\n",
       "    'direction': '西南',\n",
       "    'distance': '145.411',\n",
       "    'location': '113.585729,23.547820',\n",
       "    'address': '新城东路80号一、二层',\n",
       "    'poiweight': '0.514928',\n",
       "    'businessarea': '街口'},\n",
       "   {'id': 'B0FFG7J09R',\n",
       "    'name': '从化区综治信访维稳中心',\n",
       "    'type': '政府机构及社会团体;政府机关;区县级政府及事业单位',\n",
       "    'tel': '020-87928733',\n",
       "    'direction': '东南',\n",
       "    'distance': '84.9475',\n",
       "    'location': '113.587181,23.548300',\n",
       "    'address': '新城东路99',\n",
       "    'poiweight': '0.169373',\n",
       "    'businessarea': '街口'},\n",
       "   {'id': 'B0FFF3UQW3',\n",
       "    'name': '明师教育从化新世纪上课点',\n",
       "    'type': '科教文化服务;培训机构;培训机构',\n",
       "    'tel': '020-87957748',\n",
       "    'direction': '东南',\n",
       "    'distance': '135.505',\n",
       "    'location': '113.587312,23.547820',\n",
       "    'address': '街口镇新城东路68-1号(肯德基对面)',\n",
       "    'poiweight': '0.140757',\n",
       "    'businessarea': '街口'},\n",
       "   {'id': 'B0FFGJ24CK',\n",
       "    'name': '广州市从化区国防动员委员会',\n",
       "    'type': '政府机构及社会团体;政府机关;区县级政府及事业单位',\n",
       "    'tel': [],\n",
       "    'direction': '南',\n",
       "    'distance': '21.3686',\n",
       "    'location': '113.586615,23.548660',\n",
       "    'address': '新城东路99',\n",
       "    'poiweight': '0.165926',\n",
       "    'businessarea': '街口'},\n",
       "   {'id': 'B0FFF3UNTN',\n",
       "    'name': '东科商务·富逸财富港',\n",
       "    'type': '商务住宅;楼宇;商务写字楼',\n",
       "    'tel': '13725145988',\n",
       "    'direction': '西南',\n",
       "    'distance': '182.033',\n",
       "    'location': '113.585527,23.547547',\n",
       "    'address': '新城东路80-12',\n",
       "    'poiweight': '0.26943',\n",
       "    'businessarea': '街口'},\n",
       "   {'id': 'B00140UGAP',\n",
       "    'name': '林苑大厦(新城东路)',\n",
       "    'type': '商务住宅;楼宇;商务写字楼',\n",
       "    'tel': [],\n",
       "    'direction': '东南',\n",
       "    'distance': '188.329',\n",
       "    'location': '113.587891,23.547636',\n",
       "    'address': '新城东路68号',\n",
       "    'poiweight': '0.344929',\n",
       "    'businessarea': '街口'},\n",
       "   {'id': 'B0FFF3UW5K',\n",
       "    'name': '从化区创建平安工作领导小组办公室',\n",
       "    'type': '政府机构及社会团体;政府机关;区县级政府及事业单位',\n",
       "    'tel': [],\n",
       "    'direction': '西',\n",
       "    'distance': '106.187',\n",
       "    'location': '113.585646,23.548479',\n",
       "    'address': '新城中路7-9号附近',\n",
       "    'poiweight': '0.170039',\n",
       "    'businessarea': '街口'},\n",
       "   {'id': 'B00140J9N4',\n",
       "    'name': '从化区文化市场综合行政执法队',\n",
       "    'type': '政府机构及社会团体;政府机关;区县级政府及事业单位',\n",
       "    'tel': [],\n",
       "    'direction': '西',\n",
       "    'distance': '148.352',\n",
       "    'location': '113.585177,23.549109',\n",
       "    'address': '新城中路39',\n",
       "    'poiweight': '0.141105',\n",
       "    'businessarea': '街口'},\n",
       "   {'id': 'B00140MIC9',\n",
       "    'name': '从化商业幼儿园',\n",
       "    'type': '科教文化服务;学校;幼儿园',\n",
       "    'tel': '020-87922390',\n",
       "    'direction': '北',\n",
       "    'distance': '189.626',\n",
       "    'location': '113.586572,23.550557',\n",
       "    'address': '西宁中路',\n",
       "    'poiweight': '0.205589',\n",
       "    'businessarea': '街口'},\n",
       "   {'id': 'B00140NPDY',\n",
       "    'name': '新村居委会社区退休职工管理服务站',\n",
       "    'type': '政府机构及社会团体;政府机关;乡镇以下级政府及事业单位',\n",
       "    'tel': [],\n",
       "    'direction': '北',\n",
       "    'distance': '171.308',\n",
       "    'location': '113.586213,23.550350',\n",
       "    'address': '西宁中路148号之3附近',\n",
       "    'poiweight': '0.123706',\n",
       "    'businessarea': '街口'},\n",
       "   {'id': 'B00140NETK',\n",
       "    'name': '新村社区居委会(西宁中路五巷)',\n",
       "    'type': '政府机构及社会团体;政府机关;乡镇以下级政府及事业单位',\n",
       "    'tel': '020-87935109',\n",
       "    'direction': '西北',\n",
       "    'distance': '189.905',\n",
       "    'location': '113.585741,23.550365',\n",
       "    'address': '新村东路61-1',\n",
       "    'poiweight': '0.404627',\n",
       "    'businessarea': '街口'},\n",
       "   {'id': 'B00140NTQ0',\n",
       "    'name': '中共新村社区支部委员会(西宁中路五巷)',\n",
       "    'type': '政府机构及社会团体;政府机关;乡镇以下级政府及事业单位',\n",
       "    'tel': [],\n",
       "    'direction': '西北',\n",
       "    'distance': '189.905',\n",
       "    'location': '113.585741,23.550365',\n",
       "    'address': '新村路60号',\n",
       "    'poiweight': '0.134518',\n",
       "    'businessarea': '街口'},\n",
       "   {'id': 'B00141ID88',\n",
       "    'name': '富逸华庭',\n",
       "    'type': '商务住宅;住宅区;住宅小区',\n",
       "    'tel': [],\n",
       "    'direction': '西南',\n",
       "    'distance': '142.175',\n",
       "    'location': '113.586068,23.547672',\n",
       "    'address': '新城东路80号',\n",
       "    'poiweight': '0.348063',\n",
       "    'businessarea': '街口'},\n",
       "   {'id': 'B00141RB6B',\n",
       "    'name': '东华里',\n",
       "    'type': '商务住宅;住宅区;住宅小区',\n",
       "    'tel': [],\n",
       "    'direction': '西',\n",
       "    'distance': '179.954',\n",
       "    'location': '113.584868,23.548563',\n",
       "    'address': '新城中路10号',\n",
       "    'poiweight': '0.367551',\n",
       "    'businessarea': '街口'},\n",
       "   {'id': 'B0FFF32RLG',\n",
       "    'name': '从化区人事局',\n",
       "    'type': '政府机构及社会团体;政府机关;政府机关相关',\n",
       "    'tel': '020-87922814',\n",
       "    'direction': '南',\n",
       "    'distance': '59.3667',\n",
       "    'location': '113.586410,23.548349',\n",
       "    'address': '新城东路99号',\n",
       "    'poiweight': '0.11745',\n",
       "    'businessarea': '街口'},\n",
       "   {'id': 'B0FFF2N8SM',\n",
       "    'name': '从化区监察局',\n",
       "    'type': '政府机构及社会团体;政府机关;政府机关相关',\n",
       "    'tel': [],\n",
       "    'direction': '西南',\n",
       "    'distance': '72.9685',\n",
       "    'location': '113.586272,23.548271',\n",
       "    'address': '新城东路99号',\n",
       "    'poiweight': '0.11745',\n",
       "    'businessarea': '街口'},\n",
       "   {'id': 'B001408643',\n",
       "    'name': '从化区人民政府招待所',\n",
       "    'type': '住宿服务;旅馆招待所;旅馆招待所',\n",
       "    'tel': '020-87922022',\n",
       "    'direction': '东',\n",
       "    'distance': '108.333',\n",
       "    'location': '113.587615,23.549155',\n",
       "    'address': '街口街西宁横街75号',\n",
       "    'poiweight': '0.360069',\n",
       "    'businessarea': '街口'},\n",
       "   {'id': 'B00140TWK0',\n",
       "    'name': '肯德基甜品站(新世纪店)',\n",
       "    'type': '餐饮服务;快餐厅;肯德基',\n",
       "    'tel': '020-87939871;020-87939891',\n",
       "    'direction': '东南',\n",
       "    'distance': '180.896',\n",
       "    'location': '113.587847,23.547690',\n",
       "    'address': '新城东路66号林苑大厦1-2层',\n",
       "    'poiweight': '0.355148',\n",
       "    'businessarea': '街口'},\n",
       "   {'id': 'B0H6DUBGQ5',\n",
       "    'name': '城悦旅馆',\n",
       "    'type': '住宿服务;旅馆招待所;旅馆招待所',\n",
       "    'tel': '020-87930209;13798058272',\n",
       "    'direction': '西',\n",
       "    'distance': '183.527',\n",
       "    'location': '113.584900,23.549382',\n",
       "    'address': '新城中路41号(广播电视器材站旁)',\n",
       "    'poiweight': '0.27959',\n",
       "    'businessarea': '街口'},\n",
       "   {'id': 'B00141KB1H',\n",
       "    'name': '秋田菊寿司料理',\n",
       "    'type': '餐饮服务;外国餐厅;日本料理',\n",
       "    'tel': '13602412074',\n",
       "    'direction': '东南',\n",
       "    'distance': '111.003',\n",
       "    'location': '113.587545,23.548348',\n",
       "    'address': '街口街新城东路荔香村4栋104、107号',\n",
       "    'poiweight': '0.126091',\n",
       "    'businessarea': '街口'},\n",
       "   {'id': 'B0FFG6TUIH',\n",
       "    'name': '从化区广播电视台城区鳌头广播电视站工会委员会',\n",
       "    'type': '政府机构及社会团体;社会团体;社会团体相关',\n",
       "    'tel': [],\n",
       "    'direction': '西',\n",
       "    'distance': '150.339',\n",
       "    'location': '113.585165,23.549144',\n",
       "    'address': '新城中路39',\n",
       "    'poiweight': '0.147889',\n",
       "    'businessarea': '街口'}],\n",
       "  'roads': [{'id': '020F49F0060454023',\n",
       "    'name': '新城东路',\n",
       "    'direction': '北',\n",
       "    'distance': '81.3964',\n",
       "    'location': '113.587,23.5481'},\n",
       "   {'id': '020F49F006045608841',\n",
       "    'name': '新城东路六巷',\n",
       "    'direction': '北',\n",
       "    'distance': '92.921',\n",
       "    'location': '113.587,23.548'},\n",
       "   {'id': '020F49F006045614615',\n",
       "    'name': '新城东七巷',\n",
       "    'direction': '东北',\n",
       "    'distance': '101.004',\n",
       "    'location': '113.586,23.548'}],\n",
       "  'roadinters': [{'direction': '东北',\n",
       "    'distance': '101.004',\n",
       "    'location': '113.586194,23.548025',\n",
       "    'first_id': '020F49F0060454023',\n",
       "    'first_name': '新城东路',\n",
       "    'second_id': '020F49F006045614615',\n",
       "    'second_name': '新城东七巷'}],\n",
       "  'aois': []}}"
      ]
     },
     "execution_count": 34,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "r.json()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "2c606290",
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.8.8"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}
